﻿<%@ Page Title="" Language="C#" MasterPageFile="~/WebServisArayuz.Master" AutoEventWireup="true" CodeBehind="SFTuzelKisiTasinmazMalikIslemleri.aspx.cs" Inherits="TakbisBilgiSorgu_v1.WebForm13" EnableEventValidation = "false"%>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
<script src="js/MyScript/TuzelKisiIslemleri.js" type="text/javascript"></script>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">

<form  id="form1" runat="server">
        <div id="divTuzelKisiSorgulamaKriter" runat="server" class="DivTasinmazIslemleriBloklar">
            <div class="DivTasinmazBlokIsim">Sorgu Tipleri</div>
    <div style="clear:both"></div>
            <table class="malikTasinmazTable">
	            <tr>
                    <td>
                    <asp:Button ID="Button1" runat="server"  class="butons getirico" 
                    Text="ID İle Tüzel Kişi Getir" onclick="Button1_Click" />
                    </td>
	                <td></td>
                    <td>
                    <asp:Button ID="Button2" runat="server"  class="butons getirico" 
                    Text="Tüzel Kişi Getir" onclick="Button2_Click" />
                    </td>
                </tr>
            </table>
        <div style="clear:both"></div>
        </div>

<div id="divGetirTuzelKisiBilgiIDden" runat="server" class="DivTasinmazIslemleriBloklar">

 <div class="DivTasinmazBlokIsim">ID Bilgisi İle Tüzel Kişi Getir</div>
    <div style="clear:both"></div>

    <div class="srgtipgitsol">                     
    <table>
	                    <tr>
                            <td><asp:Label ID="Label1" runat="server" Text="TüzelKisiID"></asp:Label></td>
		                    <td>:</td>
                            <td><asp:TextBox ID="txtTuzelKisiID" runat="server" class="textboxs"></asp:TextBox></td>
		                    <td></td>
                            <td><asp:Button ID="btnTuzelKisiID" runat="server" class="butons sorguico" 
                            Text="Sorgula" onclick="btnTuzelKisiID_Click"  />
                            </td>
	                    </tr>
                    </table></div>
    <div class="srgtipgit">
   <asp:Button ID="lnkSorguTiplerineGit" class="butons gerico" runat="server" Text="Sorgu Tiplerine Git" onclick="lnkSorguTiplerineGit_Click"/>
</div>
<div style="clear:both"></div>
</div>

<div id="divGetirTuzelKisiBilgi" runat="server" class="DivTasinmazIslemleriBloklar">
 
 <div class="DivTasinmazBlokIsim">Tüzel Kişi Bilgisi İle Tüzel Kişi Getir</div>
<div class="srgtipgituzel">
   <asp:Button ID="lnkSorguTiplerineGit1" class="butons gerico" runat="server" Text="Sorgu Tiplerine Git" onclick="lnkSorguTiplerineGit1_Click" Width="205"/>
</div>
<div style="clear:both"></div>

                <div class="TuzelKisiTableSolDiv">
                    <table>
	                    <tr>
                            <td><asp:Label ID="lblAktifMi" runat="server" Text="Aktif Mi"></asp:Label></td>
		                    <td>:</td>
                            <td>
                            <asp:DropDownList ID="ddlTapuBolumDurum" class="dropdownlists" runat="server" Width="205px" TabIndex="10">
                            <asp:ListItem Value="sec">Seçiniz..</asp:ListItem>
                            <asp:ListItem Value="0">Tümü</asp:ListItem>
                            <asp:ListItem Value="2">Aktif</asp:ListItem>
                            <asp:ListItem Value="3">Pasif</asp:ListItem>
                            </asp:DropDownList></td>
	                    </tr>
	                    <tr>
		                    <td><asp:Label ID="lblBolgeTip" runat="server" Text="BölgeTip"></asp:Label></td>
		                    <td>:</td>
                            <td>
                            <asp:DropDownList ID="ddlBolgeTip" class="dropdownlists" runat="server" Width="205px" TabIndex="11">
                            <asp:ListItem Value="sec">Seçiniz..</asp:ListItem>
                            <asp:ListItem Value="0">Tüm Türkiye</asp:ListItem>
                            <asp:ListItem Value="1">İl</asp:ListItem>
                            <asp:ListItem Value="2">İlçe</asp:ListItem>
                            <asp:ListItem Value="3">Kurum</asp:ListItem>
                            <asp:ListItem Value="4">Mahalle</asp:ListItem>
                            </asp:DropDownList></td>
	                    </tr>
	                    <tr>
		                    <td>Taşınmaz Tip</td>
		                    <td></td>
                            <td>
                            <asp:DropDownList ID="ddlTasinmazTip" class="dropdownlists" runat="server" 
                                    TabIndex="8">
                                    <asp:ListItem Value="sec">Seçiniz.</asp:ListItem>
                                    <asp:ListItem Value="0">Hepsi</asp:ListItem>
                                    <asp:ListItem Value="1">AnaTasinmaz</asp:ListItem>
                                    <asp:ListItem Value="2">BagimsizBolum</asp:ListItem>
                                    <asp:ListItem Value="3">Dmh</asp:ListItem>
                                    <asp:ListItem Value="5">Kom</asp:ListItem>
                                </asp:DropDownList>
                            </td>
	                    </tr>
                    </table>

                </div>
                <div class="TuzelKisiTableOrtaDiv">
            
                    <table >
	                    <tr>
                            <td><asp:Label ID="lblBölgeID" runat="server" Text="BölgeID"></asp:Label></td>
		                    <td>:</td>
                            <td><asp:TextBox ID="txtBolgeID" class="textboxs" runat="server" TabIndex="12"></asp:TextBox></td>
	                    </tr>
	                    <tr>
		                    <td></td>
		                    <td></td>
		                    <td></td>
	                    </tr>
	                    <tr>
                            <td></td>
                            <td></td>
		                    <td><asp:Button ID="btnTuzelKisiGetir" runat="server" class="butons sorguico" TabIndex="5"
                            Text="Sorgula" onclick="btnTuzelKisiGetir_Click" Width="200" />
                            </td>
	                    </tr>
                    </table>
                </div>
                <div class="TuzelKisiTableSagDiv">

                    <table> 
	                    <tr>
		                    <td><asp:Label ID="lblAdi" runat="server" Text="Adi"></asp:Label></td>
		                    <td>:</td>
		                    <td><asp:TextBox ID="txtAd" runat="server" class="textboxs" TabIndex="2"></asp:TextBox></td>
	                    </tr>
	                    <tr>
		                    <td><asp:Label ID="lblSicil" runat="server" Text="Sicil No"></asp:Label></td>
		                    <td>:</td>
		                    <td><asp:TextBox ID="txtSicilNo" runat="server" class="textboxs" TabIndex="3"></asp:TextBox></td>
	                    </tr>
	                    <tr>
		                    <td><asp:Label ID="lblVergi" runat="server" Text="Vergi No"></asp:Label></td>
		                    <td>:</td>
		                    <td><asp:TextBox ID="txtVergiNo" runat="server" class="textboxs" TabIndex="4"></asp:TextBox></td>
	                    </tr>
                    </table>

                </div>

<div style="clear:both"></div>

        </div>

        <div id="divgvTuzelKisi" runat="server" class="DivTasinmazIslemleriBloklar">
              
              <div class="DivBlokIsim">Tüzel Kişiler</div> 

              <div class="DivExcell">    
                  <asp:Button ID="btnTuzelKisiExceleYaz" runat="server" class="butons excelli" OnClick="btnTuzelKisiExceleYaz_Click" TabIndex="9" Text="Excele Yaz" />
              </div>

              <div class="DivGrid">
                        <asp:GridView ID="gvTuzelKisi" runat="server" CssClass="grids" AllowPaging="True"
                            AutoGenerateColumns="False"   DataKeyNames="TuzelKisiID"  
                            OnPageIndexChanging="gvTuzelKisi_PageIndexChanging" OnRowCreated="gvTuzelKisi_RowCreated"
                            OnRowDataBound="gvTuzelKisi_RowDataBound">
                            <Columns>
                                <asp:CommandField HeaderText=" Seçim " SelectText="Seç " 
                                    ShowSelectButton="True" Visible="False" />

                                <asp:TemplateField HeaderText="Sec">
                                    <ItemTemplate>
                                        <asp:CheckBox ID="CheckBoxTuzelKisiBilgi" runat="server">
                                        </asp:CheckBox>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Tuzel Kisi ID" Visible="false">
                                    <ItemTemplate>
                                        <asp:Label ID="TuzelKisiID" runat="server" Text='<%# Eval("TuzelKisiID") %>'>
                                        </asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Ad">
                                    <ItemTemplate>
                                        <asp:Label ID="Ad" runat="server" Text='<%# Eval("Ad") %>'>
                                        </asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Vergi No">
                                    <ItemTemplate>
                                        <asp:Label ID="VergiNo" runat="server" Text='<%# Eval("VergiNo") %>'>
                                        </asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Sicil No">
                                    <ItemTemplate>
                                        <asp:Label ID="SicilNo" runat="server" Text='<%# Eval("SicilNo") %>'>
                                        </asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Tuzel Kişi Tip">
                                    <ItemTemplate>
                                        <asp:Label ID="TuzelKisiTipAd" runat="server" Text='<%# Eval("TuzelKisiTip.Ad") %>'>
                                        </asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                  <asp:TemplateField HeaderText="Aktif Mi">
                                    <ItemTemplate>
                                        <asp:Label ID="AktifMi" runat="server" Text='<%# Eval("AktifMi") %>'>
                                        </asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Y. TemsilciMi">
                                    <ItemTemplate>
                                        <asp:Label ID="YabanciTemsilciMi" runat="server" Text='<%# Eval("YabanciTemsilciMi") %>'>
                                        </asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Y. SermayeliMi">
                                    <ItemTemplate>
                                        <asp:Label ID="YabanciSermayeliMi" runat="server" Text='<%# Eval("YabanciSermayeliMi") %>'>
                                        </asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                  <asp:TemplateField HeaderText="Ülke Ad">
                                    <ItemTemplate>
                                        <asp:Label ID="UlkeAd" runat="server" Text='<%# Eval("Ulke.Ad") %>'>
                                        </asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateField>

                            </Columns>
                                <FooterStyle CssClass="gridsFooter"/>
                                <HeaderStyle  CssClass="gridsHeader"/>
                                <PagerStyle CssClass="gridsPager"/>
                                <RowStyle CssClass="gridsTextColor" />
                                <SelectedRowStyle CssClass="selectedRows"/>
                        </asp:GridView>
              </div>

              <div style="clear:both"></div>

       <div class="btn">
                <asp:Button ID="btnTasinmazGetir" runat="server" class="butons getirico"
                    OnClick="btnTasinmazGetir_Click" TabIndex="2" Text="Tasınmaz Getir" />
                <asp:RadioButton ID="rbTuzelKisiTasinmazAktif" runat="server" AutoPostBack="True" ForeColor="White"
                    OnCheckedChanged="rbTuzelKisiTasinmazAktif_CheckedChanged" Text="Aktif" Checked="True" />
                <asp:RadioButton ID="rbTuzelKisiTasinmazPasif" runat="server" AutoPostBack="True" ForeColor="White"
                    OnCheckedChanged="rbTuzelKisiTasinmazPasif_CheckedChanged" Text="Pasif" />
                <asp:RadioButton ID="rbTuzelKisiTasinmazHepsi" runat="server" AutoPostBack="True" ForeColor="White"
                    OnCheckedChanged="rbTuzelKisiTasinmazHepsi_CheckedChanged" Text="Hepsi" />
              </div>
<div class="srgtipgit">
   <asp:Button ID="lnkSorguTiplerineGit2" class="butons gerico" runat="server" Text="Sorgu Tiplerine Git" onclick="lnkSorguTiplerineGit2_Click"/>
</div>
<div style="clear:both"></div>
        </div>

        <div id="divgvTasinmaz" runat="server" class="DivTasinmazIslemleriBloklar">

                <div class="DivBlokIsim">Taşınmazlar</div> 

                <div class="DivExcell">    
                         <asp:Button ID="btnTuzelKisiTasinmazExceleYaz" runat="server" class="butons excelli" OnClick="btnTuzelKisiTasinmazExceleYaz_Click" TabIndex="9" Text="Excele Yaz" />
                  </div>

                <div class="DivGrid">
                     <asp:GridView ID="gvTasinmaz" CssClass="grids" runat="server" AllowPaging="True"
                            CellPadding="3" DataKeyNames="TasinmazID" OnPageIndexChanging="gvTasinmaz_PageIndexChanging"
                            OnRowCreated="gvTasinmaz_RowCreated"
                            AutoGenerateColumns="False" OnRowDataBound="gvTasinmaz_RowDataBound">
                            <Columns>
                                <asp:CommandField HeaderText=" Seçim " ShowSelectButton="True" SelectText="Seç "
                                    Visible="False" />
                                <asp:TemplateField HeaderText="İl" ItemStyle-Width="150px">
                                    <ItemTemplate>
                                        <asp:Label ID="IlAd" runat="server" Text='<%# Eval("Il.Ad") %>'>
                                        </asp:Label>
                                    </ItemTemplate>
                                    <ItemStyle Width="150px" />
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="İlçe">
                                    <ItemTemplate>
                                        <asp:Label ID="IlceAd" runat="server" Text='<%# Eval("Ilce.Ad") %>'>
                                        </asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Kurum">
                                    <ItemTemplate>
                                        <asp:Label ID="KurumAd" runat="server" Text='<%# Eval("Kurum.Ad") %>'>
                                        </asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Mahalle">
                                    <ItemTemplate>
                                        <asp:Label ID="MahalleAd" runat="server" Text='<%# Eval("Mahalle.Ad") %>'>
                                        </asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:BoundField DataField="Pafta" HeaderText="Pafta" ItemStyle-Width="150px">
                                    <ItemStyle Width="150px" />
                                </asp:BoundField>
                                <asp:BoundField DataField="Ada" HeaderText="Ada" ItemStyle-Width="150px">
                                    <ItemStyle Width="150px" />
                                </asp:BoundField>
                                <asp:BoundField DataField="Parsel" HeaderText="Parsel" ItemStyle-Width="150px">
                                    <ItemStyle Width="150px" />
                                </asp:BoundField>
                                <asp:BoundField DataField="TasinmazTip" HeaderText="Taşınmaz Tip" ItemStyle-Width="150px">
                                    <ItemStyle Width="150px" />
                                </asp:BoundField>
                                <asp:BoundField DataField="TapuBolumDurum" HeaderText="Aktif Mi" ItemStyle-Width="150px">
                                    <ItemStyle Width="150px" />
                                </asp:BoundField>
                                <asp:BoundField DataField="TasinmazID" HeaderText="TaşınmazID" ItemStyle-Width="150px"
                                    Visible="False">
                                    <ItemStyle Width="150px" />
                                </asp:BoundField>
                                <asp:BoundField DataField="Cilt" HeaderText="Cilt" ItemStyle-Width="150px">
                                    <ItemStyle Width="150px" />
                                </asp:BoundField>
                                <asp:BoundField DataField="Sayfa" HeaderText="Sayfa" ItemStyle-Width="150px">
                                    <ItemStyle Width="150px" />
                                </asp:BoundField>
                                <asp:BoundField DataField="ParselTip" HeaderText="Parsel Tip" ItemStyle-Width="150px">
                                    <ItemStyle Width="150px" />
                                </asp:BoundField>
                                <asp:BoundField DataField="ParselID" HeaderText="ParselID" ItemStyle-Width="150px"
                                    Visible="False">
                                    <ItemStyle Width="150px" />
                                </asp:BoundField>
                                <asp:BoundField DataField="Mevkii" HeaderText="Mevkii" ItemStyle-Width="150px" Visible="False">
                                    <ItemStyle Width="150px" />
                                </asp:BoundField>
                                <asp:TemplateField HeaderText="Tesis İşlemID" Visible="False">
                                    <ItemTemplate>
                                        <asp:Label ID="TesisIslemIslemBilgiID" runat="server" Text='<%# Eval("TesisIslem.IslemBilgiID") %>'>
                                        </asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Tesis İşlem Tanım Adı" Visible="False">
                                    <ItemTemplate>
                                        <asp:Label ID="TesisIslemIslemTanimAd" runat="server" Text='<%# Eval("TesisIslem.IslemTanimAd") %>'>
                                        </asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Tesis İşlem Başlama Şekli Adı" Visible="False">
                                    <ItemTemplate>
                                        <asp:Label ID="TesisIslemBaslamaSekilAd" runat="server" Text='<%# Eval("TesisIslem.BaslamaSekilAd") %>'>
                                        </asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Tesis İşlem YevmiyeID" Visible="False">
                                    <ItemTemplate>
                                        <asp:Label ID="TesisIslemYevmiyeYevmiyeBilgiID" runat="server" Text='<%# Eval("TesisIslem.Yevmiye.YevmiyeBilgiID") %>'>
                                        </asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Tesis İşlem Yevmiye No" Visible="False">
                                    <ItemTemplate>
                                        <asp:Label ID="TesisIslemYevmiyeYevmiyeNo" runat="server" Text='<%# Eval("TesisIslem.Yevmiye.YevmiyeNo") %>'>
                                        </asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Tesis İşlem Yevmiye Tarih" Visible="False">
                                    <ItemTemplate>
                                        <asp:Label ID="TesisIslemYevmiyeTarih" runat="server" Text='<%# Eval("TesisIslem.Yevmiye.Tarih","{0:dd/MM/yyyy}") %>'>
                                        </asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Tesis İşlem Yevmiye Kurum" Visible="False">
                                    <ItemTemplate>
                                        <asp:Label ID="TesisIslemYevmiyeKurum" runat="server" Text='<%# Eval("TesisIslem.Yevmiye.Kurum") %>'>
                                        </asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Terkin İşlemID" Visible="False">
                                    <ItemTemplate>
                                        <asp:Label ID="TerkinIslemIslemBilgiID" runat="server" Text='<%# Eval("TerkinIslem.IslemBilgiID") %>'>
                                        </asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Terkin İşlem Tanım Adı" Visible="False">
                                    <ItemTemplate>
                                        <asp:Label ID="TerkinIslemIslemTanimAd" runat="server" Text='<%# Eval("TerkinIslem.IslemTanimAd") %>'>
                                        </asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Terkin İşlem Başlama Şekli Adı" Visible="False">
                                    <ItemTemplate>
                                        <asp:Label ID="TerkinIslemBaslamaSekilAd" runat="server" Text='<%# Eval("TerkinIslem.BaslamaSekilAd") %>'>
                                        </asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Terkin İşlem YevmiyeID" Visible="False">
                                    <ItemTemplate>
                                        <asp:Label ID="TerkinIslemYevmiyeYevmiyeBilgiID" runat="server" Text='<%# Eval("TerkinIslem.Yevmiye.YevmiyeBilgiID") %>'>
                                        </asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Terkin İşlem Yevmiye No" Visible="False">
                                    <ItemTemplate>
                                        <asp:Label ID="TerkinIslemYevmiyeYevmiyeNo" runat="server" Text='<%# Eval("TerkinIslem.Yevmiye.YevmiyeNo") %>'>
                                        </asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Terkin İşlem Yevmiye Tarih" Visible="False">
                                    <ItemTemplate>
                                        <asp:Label ID="TerkinIslemYevmiyeTarih" runat="server" Text='<%# Eval("TerkinIslem.Yevmiye.Tarih","{0:dd/MM/yyyy}") %>'>
                                        </asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Terkin İşlem Yevmiye Kurum" Visible="False">
                                    <ItemTemplate>
                                        <asp:Label ID="TerkinIslemYevmiyeKurum" runat="server" Text='<%# Eval("TerkinIslem.Yevmiye.Kurum") %>'>
                                        </asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:BoundField DataField="AltTasinmazID" HeaderText="Alt TaşınmazID" ItemStyle-Width="150px"
                                    Visible="False">
                                    <ItemStyle Width="150px" />
                                </asp:BoundField>
                                <asp:BoundField DataField="AltTasinmazTip" HeaderText="Alt Taşınmaz Tip" ItemStyle-Width="150px"
                                    Visible="False">
                                    <ItemStyle Width="150px" />
                                </asp:BoundField>
                                <asp:BoundField DataField="AltTasinmazTapuBolumDurum" HeaderText="Alt Taşınmaz Bölüm Durumu"
                                    ItemStyle-Width="150px" Visible="False">
                                    <ItemStyle Width="150px" />
                                </asp:BoundField>
                            </Columns>
                            <FooterStyle CssClass="gridsFooter" />
                            <HeaderStyle CssClass="gridsHeader" />
                            <PagerStyle CssClass="gridsPager" />
                            <RowStyle CssClass="gridsTextColor" />
                            <SelectedRowStyle CssClass="selectedRows" />
                     </asp:GridView>
                </div>

        </div>

</form>

</asp:Content>
<asp:Content ID="Content3" runat="server" contentplaceholderid="ContentPlaceHolder2">
    <div class="sayfa_adi">Tüzel Kişi / Malik İşlemleri</div>
</asp:Content>

